<?php
namespace RH\Mountains\Domain\Repository;

/***************************************************************
 *  Copyright notice
 *
 *  (c) 2013 
 *  All rights reserved
 *
 *  This script is part of the TYPO3 project. The TYPO3 project is
 *  free software; you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation; either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  The GNU General Public License can be found at
 *  http://www.gnu.org/copyleft/gpl.html.
 *
 *  This script is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  This copyright notice MUST APPEAR in all copies of the script!
 ***************************************************************/

/**
 *
 *
 * @package hospitality_magento
 * @license http://www.gnu.org/licenses/gpl.html GNU General Public License, version 3 or later
 *
 */
class CountryRepository extends \SJBR\StaticInfoTables\Domain\Repository\CountryRepository {

	/**
	 * Finds countries by territory
	 *
	 *
	 * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array
	 */
	// public function findByIso(\string $isoCode) {
	public function findByIso($isoCode) {
		$query = $this->createQuery();
		$constraints = array();
		$constraints[] = $query->equals('cn_iso_2', $isoCode);
		$result = $query->matching($query->logicalAnd($constraints))->execute()->getFirst();
		return $result;
	}


	/**
	 * Finds countries by territory
	 *
	 *
	 * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array
	 */
	public function findAllCountries() {
		$querySettings = $this->objectManager->get('TYPO3\\CMS\\Extbase\\Persistence\\Generic\\QuerySettingsInterface');
		$querySettings->setStoragePageIds(array(0));
		$this->setDefaultQuerySettings($querySettings);
		$query = $this->createQuery();
		
		return $query->execute();
	}


	/**
	 * Finds countries by territory
	 *
	 * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array
	 */
	// public function findAllCountriesDirect() {
		// $query = $this->createQuery();
		// $selectQuery = 'SELECT uid,cn_short_fr FROM static_countries';
		// $query->statement($selectQuery);

		// $countries = $query->execute()->toArray();	
		// return $countries;
	// }
	
	
	/**
	 * Finds countries by territory
	 *
	 * @return \TYPO3\CMS\Extbase\Persistence\QueryResultInterface|array
	 */
	public function findAllCountriesDirect() {
		$query = $this->createQuery();
		$selectQuery = 'SELECT uid,cn_short_fr FROM static_countries';
		$query->statement($selectQuery);

		$countries = $query->execute()->toArray();	
		// $countries = $query->execute();
		return $countries;
		// return $query->execute();
	}
	
	
	

}
?>